UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eK5OqKycDe9jwu0sZtxWEtj57p/yjdxIqZNAluI+pCA='
WHERE
key_id = 'd28796e2d5c8025f22ed15b819fee940bad939a0ac12f182db47f92de91df2b2'
AND (
token = 'eK5OqKycDe9jwu0sZtxWEtj57p/yjdxIqZNAluI+pCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)