UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'seJhTx8rGmyta2mZwBJoYQsiGW3aN1VmD9alew/+7RI='
WHERE
key_id = '863d477f3d3d0b4b4ae4f92e682666b707ccec5260cbd42c8585fc19e0862272'
AND (
token = 'seJhTx8rGmyta2mZwBJoYQsiGW3aN1VmD9alew/+7RI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)