UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhE3rhm1nGZpTFBmHCg+0sEKHJPjF1nFryzv1xW1TpI='
WHERE
key_id = '7879e0f47fed6714a9fa7231e079bf07caacce8e7a7aff51125e7c70b952970b'
AND (
token = 'BhE3rhm1nGZpTFBmHCg+0sEKHJPjF1nFryzv1xW1TpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)