UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z9lFf8Vt8Vop1vjSVECE44ZvviQTy1IpO+yZR0aOiRQ='
WHERE
key_id = '46e605d3fc9b405ef996ece0f39637f5b311af583af203f331547f7feca269f9'
AND (
token = 'Z9lFf8Vt8Vop1vjSVECE44ZvviQTy1IpO+yZR0aOiRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)