UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lMa6q8gRVbY/WfVs1QqtudBvv6h1Mp8objycq1iwRAo='
WHERE
key_id = '9bd217ae3ae6585060a8b084847816553dff2f48a4f0e64e09655eee7fb10272'
AND (
token = 'lMa6q8gRVbY/WfVs1QqtudBvv6h1Mp8objycq1iwRAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)