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