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