UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jRcEDmFi+7sTAXINgmVqFywpJMEgBjMM3EFD1TeS/xs='
WHERE
key_id = 'e05d7968da3875d8ba0474970069cf7cf6d900076b3d98d8b838a4fc83b00d86'
AND (
token = 'jRcEDmFi+7sTAXINgmVqFywpJMEgBjMM3EFD1TeS/xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)