UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRv0kV5zf8tph3d/dwKQmbWllhPNJU/B+mq1yXUVr6E='
WHERE
key_id = '309e5577ff91003b0622458a06c6b2d05cfedb45f4392f740ad2b031ef21a1be'
AND (
token = 'pRv0kV5zf8tph3d/dwKQmbWllhPNJU/B+mq1yXUVr6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)