UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cg4nQ0mWC+tMBrbQ+mFrbHf4jsx0wsTfPnkpzgEkMvI='
WHERE
key_id = 'bcff020280729f436200001a1f8ab52ec71a167a0137ef7ae870907db214245b'
AND (
token = 'cg4nQ0mWC+tMBrbQ+mFrbHf4jsx0wsTfPnkpzgEkMvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)