UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9U6bjTjBN6IcR51iR8PUOJXi4bjG2TGTRVaRXnN/NmU='
WHERE
key_id = '0ef49405b1f30590875511e55fa43956d96eac19f5d8c66522e806f58c9cc401'
AND (
token = '9U6bjTjBN6IcR51iR8PUOJXi4bjG2TGTRVaRXnN/NmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)