UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLzUgpTkMEol/SwKIxO7Vm33zDOmyOVnU04+mHTNdZw='
WHERE
key_id = '58f23f00591cfe4831e64cf91fb3cec75ef9640e9a1855279ec54282a4b620d8'
AND (
token = 'BLzUgpTkMEol/SwKIxO7Vm33zDOmyOVnU04+mHTNdZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)