UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JKUzhnYXSyKa9F+sAyrV7fGVXAexVpRqMABlTDJ19Gg='
WHERE
key_id = '47b516f175305db91a355601ae69586b115b2bf11077886e6940aca3ed60eb28'
AND (
token = 'JKUzhnYXSyKa9F+sAyrV7fGVXAexVpRqMABlTDJ19Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)