UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3ubGd7t4G8mRkQrcEynOmdn3RD8N1oDj86/s8GjQ17o='
WHERE
key_id = '02aa77533c22116a8fbe4a0d82d5b32cd47a17dc1b7b99b8ac47050f09ae1394'
AND (
token = '3ubGd7t4G8mRkQrcEynOmdn3RD8N1oDj86/s8GjQ17o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)