UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g5P46HAGHG3+1+Is4OxCfsqumb+Yy5ef9VxBxUs6KGA='
WHERE
key_id = 'bed69a138c06b74f24fc3d7cb01c438a8ecfd9d985d9abc57940b11d66718a43'
AND (
token = 'g5P46HAGHG3+1+Is4OxCfsqumb+Yy5ef9VxBxUs6KGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)