UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yWC7m65qGzmSggJ0vEiHNZHwkEWXG2/nDLwCUYOufvk='
WHERE
key_id = '786d3bc5caa50073df0d284f54132079593e4a4dbfc2efcc338585e3d2dc3cb3'
AND (
token = 'yWC7m65qGzmSggJ0vEiHNZHwkEWXG2/nDLwCUYOufvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)