UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/pdw5i3rGko+lHoUOGD3+7SouTL6dGYZUnRiMYQLjKA='
WHERE
key_id = '04f5b5e4e76cc49ea543da1bf7c1b74b169105d8a7b0f185d709f9e9425189a9'
AND (
token = '/pdw5i3rGko+lHoUOGD3+7SouTL6dGYZUnRiMYQLjKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)