UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RS+Shkv4P7hF3hcQhOCouW3t6dSWwhZZMje8hGZFSCs='
WHERE
key_id = 'ec5823fbc0dd4e776dbb8689b3127485e6380a8aab1bf93696439700779e7752'
AND (
token = 'RS+Shkv4P7hF3hcQhOCouW3t6dSWwhZZMje8hGZFSCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)