UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HT8wnNhT39ebZkakdkW6iyA2F+FlGiRJsxQ6A8rSZoM='
WHERE
key_id = '42e19442ecc826658053f4285bf7c7b615602ae1dbaf79428362b34dab7c94e5'
AND (
token = 'HT8wnNhT39ebZkakdkW6iyA2F+FlGiRJsxQ6A8rSZoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)