UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7CbWOU0OytdSlpOCOf5tZeedYmbVBJvamgfgWpPtVs='
WHERE
key_id = 'b44d3d183ee3f781a0c839b8d0828407f83cd72afa9fec683b32e748c172fc04'
AND (
token = 'D7CbWOU0OytdSlpOCOf5tZeedYmbVBJvamgfgWpPtVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)