UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/6bQcJWadVA+vGo2de5nGFFtYuUrNBY5/bFSE6s/PxA='
WHERE
key_id = '135e10467fd32fbee50b1c75248fc9aa2c7d2ae8b9edde5fd3fa903e46f5c2b5'
AND (
token = '/6bQcJWadVA+vGo2de5nGFFtYuUrNBY5/bFSE6s/PxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)