UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J0LyjQpiG6A6JVkgqb46IOechyYrbyRn6LzSFOgLQD0='
WHERE
key_id = '719ecc7eb510fc6ad0c6509e4c0def7a17be09c3e72ce90a917304184687c4f3'
AND (
token = 'J0LyjQpiG6A6JVkgqb46IOechyYrbyRn6LzSFOgLQD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)