UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNNQrzxEhemP94SMxeMusMMm5y5OQ16zBgjwTtccMrg='
WHERE
key_id = '4df31e4e5f769079138e9e8797895ca1e0d2c4060475b48010aac28d87473175'
AND (
token = 'pNNQrzxEhemP94SMxeMusMMm5y5OQ16zBgjwTtccMrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)