UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIauKhuJLBaADV1Rt+yXdwEU7E0O4NgrxYjoG91j9gI='
WHERE
key_id = '31d3696fb1062485300126e79fdc6dd9f232c5d298486523a5a057ea3c664152'
AND (
token = 'ZIauKhuJLBaADV1Rt+yXdwEU7E0O4NgrxYjoG91j9gI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)