UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V5xGCsLcbbCOgWRZTZYrDc7lp/IoVnU278b1VgOk8J8='
WHERE
key_id = 'fdf55bc10ea98250603afc59cf6637e264030b2c3f34177a62228f1373e3fea1'
AND (
token = 'V5xGCsLcbbCOgWRZTZYrDc7lp/IoVnU278b1VgOk8J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)