UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3kbeIy4eU3VH1g1Y4B2pzFscv8N6OTlMMtKJrrwAjd8='
WHERE
key_id = '5fa87bbc441d52be667075ca5ddf3e81ae4e4af8f9c8d92c38953e29110ae1f5'
AND (
token = '3kbeIy4eU3VH1g1Y4B2pzFscv8N6OTlMMtKJrrwAjd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)