UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WClCJRIOsw7FRaH/9drdv2caV8ifKVhUV4y9c9wY/bM='
WHERE
key_id = 'e00827b6620854ec395dde8266876581ec5263d72c37edfc7c5dce25e0ed0ff3'
AND (
token = 'WClCJRIOsw7FRaH/9drdv2caV8ifKVhUV4y9c9wY/bM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)