UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2gSB9KLtU+sR5fy2gt6g6XOe4P5nZUNgcxvP+4Abxk='
WHERE
key_id = '40e789507153d103fe06d21c9dbdd3fa0f3d976b33908c2a54e7c021eb6ec841'
AND (
token = 'z2gSB9KLtU+sR5fy2gt6g6XOe4P5nZUNgcxvP+4Abxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)