UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BmaD5y1QaFmQJWTVEW6RA33uw58du0UYZy0oI8AG4Q8='
WHERE
key_id = 'bcf51bae6063cfb5246948d971f5188bd5494018c784f2e36968edd0ec34d5bd'
AND (
token = 'BmaD5y1QaFmQJWTVEW6RA33uw58du0UYZy0oI8AG4Q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)