UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vhsad4MPtjmo53HgcICJ/16+0+qh5tqei4KicpD600Y='
WHERE
key_id = 'b1fc4c6916396cadeb53cd6674fed1a35a2f3127fd380854d85e746ca2b49a8d'
AND (
token = 'vhsad4MPtjmo53HgcICJ/16+0+qh5tqei4KicpD600Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)